package com.workManager.mapper;

import com.workManager.pojo.TbEstimate;
import com.workManager.pojo.TbEstimateExample;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface TbEstimateMapper {
    int countByExample(TbEstimateExample example);

    int deleteByExample(TbEstimateExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(TbEstimate record);

    int insertSelective(TbEstimate record);

    List<TbEstimate> selectByExample(TbEstimateExample example);

    TbEstimate selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") TbEstimate record, @Param("example") TbEstimateExample example);

    int updateByExample(@Param("record") TbEstimate record, @Param("example") TbEstimateExample example);

    int updateByPrimaryKeySelective(TbEstimate record);

    int updateByPrimaryKey(TbEstimate record);

    List<Map<String, Object>> queryActualCost(List list);

    List queryIndirect(List list);

    List<Map<String,Object>> queryNeedCost(List list);

    List<Map<String,Object>> queryTotalCost(List list);

    List<String> queryYearList(List list);

    List<Map<String, Object>> queryEstimateProfit(@Param("year")String year,@Param("list") List list);

}